Magnet link info for 'Lynda - Office 2016 for Mac Essential Training: Excel-5c157245165a6b84b39608a1ccb9fece2aab4173',download 'Lynda - Office 2016 for Mac Essential Training: Excel'

Files list

019 Restricting input using validation rules.mp4 16.91MB

044 Managing scenarios.mp4 15.95MB

054 Defining data bar, color scale, and icon set conditional formats.mp4 15.91MB

025 Splitting and freezing rows and columns.mp4 15.15MB

085 Filtering a PivotTable report.mp4 14.91MB

016 Creating named ranges.mp4 14.71MB

037 Summarizing data using SUMIF and other conditional functions.mp4 14.40MB

018 Locating and changing data using Find and Replace.mp4 13.79MB

051 Managing Office themes.mp4 13.60MB

031 Using relative and absolute cell references.mp4 13.17MB

072 Adding and adjusting images.mp4 13.05MB

071 Creating and formatting shapes.mp4 12.68MB

015 Inserting symbols and special characters.mp4 12.12MB

077 Aligning and layering objects.mp4 11.99MB

074 Cropping, compressing, and removing image backgrounds.mp4 11.96MB

056 Creating bar and column charts.mp4 11.95MB

047 Applying number and date formats to cells.mp4 11.94MB

083 Changing the data field summary operation.mp4 11.90MB

046 Applying fonts, background colors, and borders.mp4 11.84MB

004 Exploring the Excel 2016 program window.mp4 11.72MB

026 Managing worksheets.mp4 11.43MB

022 Creating a custom sort order.mp4 11.41MB

053 Defining top 10 conditional formats.mp4 10.93MB

036 Summarizing data using an IF function.mp4 10.74MB

052 Creating rule-based conditional formats.mp4 10.68MB

048 Managing text alignment.mp4 10.61MB

050 Managing cell styles.mp4 10.56MB

017 Creating an Excel table.mp4 10.47MB

032 Controlling how Excel copies and pastes formulas.mp4 10.29MB

006 Setting program preferences.mp4 10.19MB

043 Managing Excel formula error indicators.mp4 10.12MB

088 Setting AutoCorrect and automatic Replace options.mp4 9.99MB

030 Introducing arithmetic operators.mp4 9.97MB

013 Copying and pasting cell data.mp4 9.95MB

090 Tracking and reviewing changes.mp4 9.89MB

012 Selecting cells and groups of cells.mp4 9.84MB

065 Creating sparkline charts.mp4 9.81MB

024 Inserting, moving, and deleting cells and cell ranges.mp4 9.70MB

005 Introducing the Ribbon for the Mac.mp4 9.70MB

055 Editing, ordering, and deleting conditional formats.mp4 9.62MB

075 Creating SmartArt graphics.mp4 9.52MB

068 Using hyperlinks.mp4 9.50MB

034 Creating an AutoSum formula.mp4 9.40MB

039 Rounding cell values.mp4 9.06MB

029 Adding a formula to a cell.mp4 9.04MB

066 Importing data from comma-separated value (CSV) or text files.mp4 8.94MB

014 Entering data using AutoFill and other techniques.mp4 8.78MB

023 Filtering worksheet data.mp4 8.77MB

010 Creating and modifying workbook templates.mp4 8.55MB

033 Referring to Excel table data in formulas.mp4 8.33MB

008 Opening, creating, and saving workbooks.mp4 8.33MB

027 Creating, editing, and deleting headers and footers.mp4 8.27MB

040 Joining text in cells with concatenation.mp4 8.09MB

062 Changing the appearance of chart elements.mp4 8.08MB

069 Including an Excel workbook in another Office document.mp4 8.06MB

007 Getting help in Excel.mp4 7.95MB

049 Copying cell formats.mp4 7.91MB

073 Manipulating text boxes.mp4 7.88MB

064 Adding trendlines to charts.mp4 7.87MB

095 Running an existing macro.mp4 7.86MB

081 Managing subtotals and grand totals.mp4 7.80MB

041 Finding data using VLOOKUP and HLOOKUP.mp4 7.77MB

099 Turning off screen updating in a macro.mp4 7.77MB

094 Protecting a workbook.mp4 7.53MB

079 Creating a PivotTable report.mp4 7.47MB

021 Sorting worksheet data.mp4 7.44MB

089 Managing workbook comments.mp4 7.43MB

058 Creating line charts.mp4 7.43MB

080 Pivoting a PivotTable report.mp4 7.30MB

020 Using lists to limit data entered into a cell.mp4 6.91MB

011 Managing workbooks across multiple versions of Excel.mp4 6.83MB

042 Auditing formulas by identifying precedents and dependents.mp4 6.80MB

063 Managing chart axes and numbering.mp4 6.77MB

028 Introducing Excel formulas and functions.mp4 6.76MB

091 Printing a worksheet or workbook.mp4 6.72MB

078 Introducing PivotTable reports.mp4 6.66MB

045 Performing Goal Seek analysis.mp4 6.66MB

093 Exporting to other formats.mp4 6.64MB

087 Checking spelling.mp4 6.47MB

003 What you can do with Excel 2016.mp4 6.42MB

096 Recording a macro.mp4 6.37MB

086 Applying a PivotTable style.mp4 6.36MB

076 Creating WordArt.mp4 6.26MB

009 Setting workbook properties.mp4 6.17MB

097 Renaming, viewing, and deleting macros.mp4 6.10MB

092 Setting and removing print areas.mp4 6.07MB

038 Creating formulas to count cells.mp4 6.02MB

060 Creating stock charts.mp4 5.94MB

061 Changing chart types and layouts.mp4 5.80MB

070 Linking to an Excel chart from another Office program.mp4 5.74MB

098 Adding comments to a macro.mp4 5.62MB

059 Creating XY (scatter) charts.mp4 5.60MB

057 Creating pie charts.mp4 5.51MB

035 Summarizing data on the status bar.mp4 5.29MB

001 Welcome.mp4 4.97MB

084 Changing the data field number format.mp4 4.66MB

082 Summarizing more than one data field.mp4 4.60MB

067 Connecting to an external data source.mp4 3.40MB

100 Next steps.mp4 3.20MB

002 Using the exercise files.mp4 1004.85KB

Exercise Files,Chapter10,Aligning.xlsx 63.75KB

Exercise Files,Chapter13,ManageMacros.xlsm 40.35KB

Exercise Files,Chapter13,NoFlash.xlsm 39.92KB

Exercise Files,Chapter10,ManageImages.xlsx 36.57KB

Exercise Files,Chapter07,CellStyle.xlsx 33.73KB

Exercise Files,Chapter03,ManageCells.xlsx 33.63KB

Exercise Files,Chapter07,CopyFormat.xlsx 32.77KB

Exercise Files,Chapter07,CellFormats.xlsx 31.30KB

Exercise Files,Chapter07,NewConds.xlsx 31.02KB

Exercise Files,Chapter07,MngConds.xlsx 29.22KB

Exercise Files,Chapter07,BasicFormatting.xlsx 28.52KB

Exercise Files,Chapter12,AutoCorrect.xlsx 28.38KB

Exercise Files,Chapter07,Themes.xlsx 27.96KB

Exercise Files,Chapter03,Symbols.xlsx 27.82KB

Exercise Files,Chapter13,Comments.xlsm 27.72KB

Exercise Files,Chapter07,Conditional.xlsx 26.95KB

Exercise Files,Chapter07,NumberFormats.xlsx 26.71KB

Exercise Files,Chapter07,Alignment.xlsx 25.94KB

Exercise Files,Chapter07,TopTen.xlsx 24.83KB

Exercise Files,Chapter13,Record.xlsx 24.16KB

Exercise Files,Chapter13,Relative.xlsm 22.63KB

Exercise Files,Chapter13,Relative.xlsx 22.12KB

Exercise Files,Chapter10,London.jpg 21.05KB

Exercise Files,Chapter09,LinkToWeb.xlsx 19.04KB

Exercise Files,Chapter11,Styles.xlsx 18.04KB

Exercise Files,Chapter09,PivotReport.xlsx 17.97KB

Exercise Files,Chapter11,Filters.xlsx 17.80KB

Exercise Files,Chapter11,DataFormat.xlsx 17.74KB

Exercise Files,Chapter11,MultipleDataFields.xlsx 17.14KB

Exercise Files,Chapter11,Totals.xlsx 17.05KB

Exercise Files,Chapter11,PivotIntro.xlsx 17.01KB

Exercise Files,Chapter11,SummaryOperation.xlsx 16.97KB

Exercise Files,Chapter09,WebData.htm 16.80KB

Exercise Files,Chapter10,WestEnd.jpg 16.48KB

Exercise Files,Chapter11,Pivoting.xlsx 16.29KB

Exercise Files,Chapter10,WomanShopping.jpg 15.63KB

Exercise Files,Chapter04,MoveTarget.xlsx 15.29KB

Exercise Files,Chapter13,RunAMacro.xlsm 15.08KB

Exercise Files,Chapter08,ChartElements.xlsx 14.94KB

Exercise Files,Chapter08,ChartLayout.xlsx 14.94KB

Exercise Files,Chapter08,ChartAxes.xlsx 14.82KB

Exercise Files,Chapter08,Trendline.xlsx 14.39KB

Exercise Files,Chapter04,RegentStreet.jpg 13.51KB

Exercise Files,Chapter01,WhatToDo.xlsx 13.31KB

Exercise Files,Chapter01,RibbonTour.xlsx 12.95KB

Exercise Files,Chapter09,ChartLink.xlsx 12.52KB

Exercise Files,Chapter04,Freeze.xlsx 12.42KB

Exercise Files,Chapter10,TextBox.xlsx 12.40KB

Exercise Files,Chapter03,ManageWorksheets.xlsx 12.10KB

Exercise Files,Chapter04,ManageWorksheets.xlsx 11.96KB

Exercise Files,Chapter02,FileManagement.xlsx 11.76KB

Exercise Files,Chapter09,Summary.docx 11.67KB

Exercise Files,Chapter09,Chart.docx 11.51KB

Exercise Files,Chapter11,CreatePivot.xlsx 11.47KB

Exercise Files,Chapter12,Print.xlsx 11.35KB

Exercise Files,Chapter03,FreezeSplit.xlsx 11.26KB

Exercise Files,Chapter03,CopyPaste.xlsx 11.01KB

Exercise Files,Chapter03,EnterData.xlsx 10.97KB

Exercise Files,Chapter03,Headers.xlsx 10.94KB

Exercise Files,Chapter04,Headers.xlsx 10.89KB

Exercise Files,Chapter03,NamedRanges.xlsx 10.86KB

Exercise Files,Chapter04,ExcelTables.xlsx 10.85KB

Exercise Files,Chapter03,Select.xlsx 10.81KB

Exercise Files,Chapter12,NewFormat.xlsx 10.70KB

Exercise Files,Chapter01,Preferences.xlsx 10.55KB

Exercise Files,Chapter01,GettingHelp.xlsx 10.41KB

Exercise Files,Chapter06,Tracing.xlsx 10.32KB

Exercise Files,Chapter02,SalesReport.xlsx 10.12KB

Exercise Files,Chapter08,XYChart.xlsx 10.09KB

Exercise Files,Chapter12,Protect.xlsx 10.03KB

Exercise Files,Chapter12,PrintAreas.xlsx 10.03KB

Exercise Files,Chapter08,StockChart.xlsx 10.03KB

Exercise Files,Chapter02,Versions.xlsx 10.02KB

Exercise Files,Chapter06,ErrorIndicators.xlsx 10.00KB

Exercise Files,Chapter03,Validation.xlsx 9.99KB

Exercise Files,Chapter05,ExcelTables.xlsx 9.98KB

Exercise Files,Chapter04,Sort.xlsx 9.94KB

Exercise Files,Chapter04,CustomSort.xlsx 9.91KB

Exercise Files,Chapter09,Include.xlsx 9.88KB

Exercise Files,Chapter06,GoalSeek.xlsx 9.85KB

Exercise Files,Chapter08,Sparkline.xlsx 9.83KB

Exercise Files,Chapter03,ValidList.xlsx 9.75KB

Exercise Files,Chapter02,Properties.xlsx 9.74KB

Exercise Files,Chapter12,Comments.xlsx 9.69KB

Exercise Files,Chapter12,Changes.xlsx 9.69KB

Exercise Files,Chapter03,ExcelTables.xlsx 9.67KB

Exercise Files,Chapter08,PieChart.xlsx 9.67KB

Exercise Files,Chapter04,Filter.xlsx 9.66KB

Exercise Files,Chapter04,ManageCells.xlsx 9.65KB

Exercise Files,Chapter08,LineChart.xlsx 9.65KB

Exercise Files,Chapter08,ColumnChart.xlsx 9.64KB

Exercise Files,Chapter06,Concatenate.xlsx 9.60KB

Exercise Files,Chapter03,Find.xlsx 9.55KB

Exercise Files,Chapter12,Spelling.xlsx 9.54KB

Exercise Files,Chapter05,CopyFormulas.xlsx 9.50KB

Exercise Files,Chapter09,Hyperlinks.xlsx 9.50KB

Exercise Files,Chapter06,Counting.xlsx 9.36KB

Exercise Files,Chapter05,CreatingFormulas.xlsx 9.31KB

Exercise Files,Chapter06,Rounding.xlsx 9.27KB

Exercise Files,Chapter06,VLookup.xlsx 9.10KB

Exercise Files,Chapter05,AutoSum.xlsx 8.99KB

Exercise Files,Chapter10,Shapes.xlsx 8.77KB

Exercise Files,Chapter10,Images.xlsx 8.77KB

Exercise Files,Chapter05,Conditional.xlsx 8.75KB

Exercise Files,Chapter10,SmartArt.xlsx 8.74KB

Exercise Files,Chapter10,WordArt.xlsx 8.74KB

Exercise Files,Chapter05,CellRefs.xlsx 8.71KB

Exercise Files,Chapter09,ImportTarget.xlsx 8.70KB

Exercise Files,Chapter06,ManageScenarios.xlsx 8.63KB

Exercise Files,Chapter05,StatusBar.xlsx 8.53KB

Exercise Files,Chapter05,IfFormulas.xlsx 8.25KB

Exercise Files,Chapter05,FormulaIntro.xlsx 8.19KB

Exercise Files,Chapter05,Operators.xlsx 8.19KB

Exercise Files,Chapter03,landon_final.png 5.05KB

Exercise Files,Chapter09,ImportCSV.csv 1.47KB